package com.sky.service.impl;

import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import com.sky.constant.MessageConstant;
import com.sky.constant.PasswordConstant;
import com.sky.constant.StatusConstant;
import com.sky.context.BaseContext;
import com.sky.dto.EmployeeDTO;
import com.sky.dto.EmployeeLoginDTO;
import com.sky.dto.EmployeePageQueryDTO;
import com.sky.entity.Employee;
import com.sky.exception.AccountLockedException;
import com.sky.exception.AccountNotFoundException;
import com.sky.exception.PasswordErrorException;
import com.sky.mapper.EmployeeMapper;
import com.sky.result.PageResult;
import com.sky.service.EmployeeService;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.DigestUtils;
import org.springframework.web.bind.annotation.PathVariable;

import java.time.LocalDateTime;
import java.util.List;

@Service
public class EmployeeServiceImpl implements EmployeeService {

    @Autowired
    private EmployeeMapper employeeMapper;

    /**
     * 员工登录
     *
     * @param employeeLoginDTO
     * @return
     */
    public Employee login(EmployeeLoginDTO employeeLoginDTO) {
        String username = employeeLoginDTO.getUsername();
        String password = employeeLoginDTO.getPassword();

        //1、根据用户名查询数据库中的数据
        Employee employee = employeeMapper.getByUsername(username);

        //2、处理各种异常情况（用户名不存在、密码不对、账号被锁定）
        if (employee == null) {
            //账号不存在
            throw new AccountNotFoundException(MessageConstant.ACCOUNT_NOT_FOUND);
        }

        //密码比对

        password = DigestUtils.md5DigestAsHex(password.getBytes());
        if (!password.equals(employee.getPassword())) {
            //密码错误
            throw new PasswordErrorException(MessageConstant.PASSWORD_ERROR);
        }

        if (employee.getStatus() == StatusConstant.DISABLE) {
            //账号被锁定
            throw new AccountLockedException(MessageConstant.ACCOUNT_LOCKED);
        }

        //3、返回实体对象
        return employee;
    }



    /**
     * 新增员工
     * @param employeeDto
     */
    @Override
    public void save(EmployeeDTO employeeDto) {
        System.out.println("当前线程的id" + Thread.currentThread().getId());
        Employee employee = new Employee();
        BeanUtils.copyProperties(employeeDto,employee);

        //设置账号状态默认正常状态 1-正常 2-表示锁定
        employee.setStatus(StatusConstant.ENABLE);

        //设置密码默认密码是123456
        employee.setPassword(DigestUtils.md5DigestAsHex(PasswordConstant.DEFAULT_PASSWORD.getBytes()));

        //设置当前记录的创建时间和修改时间
        employee.setCreateTime(LocalDateTime.now());
        employee.setUpdateTime(LocalDateTime.now());

        //设置当前记录创建人id和修改人ID

        employee.setCreateUser(BaseContext.getCurrentId());
        employee.setUpdateUser(BaseContext.getCurrentId());

        employeeMapper.insert(employee);

    }

    /**
     * 分页查询
     * @param employeePageQueryDTO
     * @return
     */
    public PageResult pageQuery(EmployeePageQueryDTO employeePageQueryDTO) {
        //分页查询
        // 这是mybatis的一个插件里面提供了分页查询的方法====》PageHelper.startPage（参数1，参数2）
        //                                              开始分页查询          页码，每页记录数
//                                                                           page pagesize
//        底层是线程的存储，会将生成的limit语句（分页语句）动态的加入到sql语句中
        PageHelper.startPage(employeePageQueryDTO.getPage(),employeePageQueryDTO.getPageSize());
//         使用了上面的mybatis 给的分页查询的方法 返回值类型就要固定为   Page
        Page<Employee>  page = employeeMapper.pageQuery(employeePageQueryDTO);
//Preparing: SELECT count(0) FROM employee
//Parameters:
//       Total: 1
//Preparing: select * from employee order by create_time desc LIMIT ?
//Parameters: 1(Integer)
//      Total: 1
        long total =page.getTotal();
        List<Employee> records = page.getResult();
        return new PageResult(total,records);
    }


    public void startOrStop(Integer status, Long id) {

        Employee employee =Employee.builder()
                .status(status)
                .id(id)
                .build();
        employeeMapper.update(employee);

    }

    /**
     * 根据id查询员工信息
     * @param id
     */
    public Employee getById(Long id) {
        Employee employee = employeeMapper.geyById(id);
        //密码不能返回因为是密码
        employee.setPassword("****");
        return employee;
    }

    /**
     * 编辑员工信息
     * @param employeeDTO
     */
   public void update(EmployeeDTO employeeDTO){
        Employee employee = new Employee();
        BeanUtils.copyProperties(employeeDTO,employee);
        //当前系统时间LocalDateTime.now()
        employee.setUpdateTime(LocalDateTime.now());
        //BaseContext.getCurrentId()==》threadLocal等于说是id在线程中存储着
        employee.setUpdateUser(BaseContext.getCurrentId());

        employeeMapper.update(employee);
    }

}
